package dev.bong.mapper;

import dev.bong.pojo.entity.Lab;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface LabMapper {

    @Select("select id from lab where experimenter_id = #{experimenterId}")
    List<Integer> getIdsByExpId(int experimenterId);

    @Select("select lab_name from lab where id = #{id}")
    String getLabNameById(Integer id);


    @Select("select id from lab where lab_number = #{labNumber}")
    Integer getLabIdByLabNumber(String labNumber);

    List<Lab> getLabList();
}
